Overview

Brought to you by YData

Dataset statistics

Number of variables	25
Number of observations	14787
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.8 MiB
Average record size in memory	200.0 B

Variable types

Text	8
DateTime	1
Categorical	4
Numeric	12

Alerts

`actual_distance_to_destination` is highly overall correlated with `actual_time` and 8 other fields	High correlation
`actual_time` is highly overall correlated with `actual_distance_to_destination` and 7 other fields	High correlation
`dest_state` is highly overall correlated with `source_state`	High correlation
`od_time_diff_hour` is highly overall correlated with `actual_distance_to_destination` and 8 other fields	High correlation
`osrm_distance` is highly overall correlated with `actual_distance_to_destination` and 8 other fields	High correlation
`osrm_time` is highly overall correlated with `actual_distance_to_destination` and 8 other fields	High correlation
`route_type` is highly overall correlated with `actual_distance_to_destination` and 5 other fields	High correlation
`segment_actual_time_sum` is highly overall correlated with `actual_distance_to_destination` and 7 other fields	High correlation
`segment_osrm_distance_sum` is highly overall correlated with `actual_distance_to_destination` and 7 other fields	High correlation
`segment_osrm_time_sum` is highly overall correlated with `actual_distance_to_destination` and 8 other fields	High correlation
`source_state` is highly overall correlated with `dest_state`	High correlation
`start_scan_to_end_scan` is highly overall correlated with `actual_distance_to_destination` and 8 other fields	High correlation
`trip_day` is highly overall correlated with `trip_month`	High correlation
`trip_month` is highly overall correlated with `trip_day`	High correlation
`trip_uuid` has unique values	Unique
`trip_creation_time` has unique values	Unique
`od_time_diff_hour` has unique values	Unique
`trip_hour` has 991 (6.7%) zeros	Zeros
`trip_dayofweek` has 1980 (13.4%) zeros	Zeros

Reproduction

Analysis started	2025-04-24 17:19:51.037758
Analysis finished	2025-04-24 17:20:16.423801
Duration	25.39 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

trip_uuid
Text

Unique

Distinct	14787
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	24
Median length	23
Mean length	23.000744
Min length	23

Characters and Unicode

Total characters	340112
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14787 ?
Unique (%)	100.0%

Sample

1st row	trip-153671041653548748
2nd row	trip-153671042288605164
3rd row	trip-153671043369099517
4th row	trip-153671046011330457
5th row	trip-153671052974046625

Value	Count	Frequency (%)
trip-153671046011330457	1	< 0.1%
trip-153861118270144424	1	< 0.1%
trip-153671041653548748	1	< 0.1%
trip-153861042148375909	1	< 0.1%
trip-153861052318770017	1	< 0.1%
trip-153861055072891350	1	< 0.1%
trip-153861059679001096	1	< 0.1%
trip-153861073259859847	1	< 0.1%
trip-153861075467184898	1	< 0.1%
trip-153861089403973335	1	< 0.1%
Other values (14777)	14777	99.9%

Most occurring characters

Value	Count	Frequency (%)
5	35458	10.4%
3	35367	10.4%
1	35141	10.3%
7	28883	8.5%
8	25138	7.4%
6	22675	6.7%
0	21072	6.2%
9	20942	6.2%
2	20831	6.1%
4	20670	6.1%
Other values (5)	73935	21.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	340112	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	35458	10.4%
3	35367	10.4%
1	35141	10.3%
7	28883	8.5%
8	25138	7.4%
6	22675	6.7%
0	21072	6.2%
9	20942	6.2%
2	20831	6.1%
4	20670	6.1%
Other values (5)	73935	21.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	340112	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	35458	10.4%
3	35367	10.4%
1	35141	10.3%
7	28883	8.5%
8	25138	7.4%
6	22675	6.7%
0	21072	6.2%
9	20942	6.2%
2	20831	6.1%
4	20670	6.1%
Other values (5)	73935	21.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	340112	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	35458	10.4%
3	35367	10.4%
1	35141	10.3%
7	28883	8.5%
8	25138	7.4%
6	22675	6.7%
0	21072	6.2%
9	20942	6.2%
2	20831	6.1%
4	20670	6.1%
Other values (5)	73935	21.7%

trip_creation_time
Date

Unique

Distinct	14787
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Minimum	2018-09-12 00:00:16.535741
Maximum	2018-10-03 23:59:42.701692
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

route_schedule_uuid
Text

Distinct	1497
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	51
Median length	51
Mean length	51
Min length	51

Characters and Unicode

Total characters	754137
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	160 ?
Unique (%)	1.1%

Sample

1st row	thanos::sroute:d7c989ba-a29b-4a0b-b2f4-288cdc60074b
2nd row	thanos::sroute:3a1b0ab2-bb0b-4c53-8c59-eb2a2c0d68b9
3rd row	thanos::sroute:de5e208e-7641-45e6-8100-4d9fb1e5720d
4th row	thanos::sroute:f0176492-a679-4597-8332-bbd1c7f9f442
5th row	thanos::sroute:d9f07b12-65e0-4f3b-bec8-df0613461b0f

Value	Count	Frequency (%)
thanos::sroute:a16bfa03-3462-4bce-9c82-5784c7d315e6	53	0.4%
thanos::sroute:8e6cd941-adb5-4f66-b44f-84938f5fca03	46	0.3%
thanos::sroute:c736b86f-5c1d-4497-832c-876db4c1a518	43	0.3%
thanos::sroute:ca336899-47aa-4622-9885-b9fbb2302aeb	41	0.3%
thanos::sroute:5f8fb6cf-814a-426f-b2c9-8665b605d343	40	0.3%
thanos::sroute:3a78a6e9-ef19-43ae-832e-e4a3868eb32d	39	0.3%
thanos::sroute:5dd1132a-b8a0-4b55-9df1-08937607bb65	37	0.3%
thanos::sroute:b743d024-a50a-40a4-8ffd-e3b420b7534e	36	0.2%
thanos::sroute:ad01057e-be3e-42d5-8380-4fd6d174ec89	35	0.2%
thanos::sroute:faef8565-4919-4d38-b5a6-a81f9c1da35c	34	0.2%
Other values (1487)	14383	97.3%

Most occurring characters

Value	Count	Frequency (%)
-	59148	7.8%
a	47233	6.3%
:	44361	5.9%
e	42479	5.6%
4	41899	5.6%
9	31478	4.2%
8	31234	4.1%
b	30824	4.1%
t	29574	3.9%
o	29574	3.9%
Other values (15)	366333	48.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	754137	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	59148	7.8%
a	47233	6.3%
:	44361	5.9%
e	42479	5.6%
4	41899	5.6%
9	31478	4.2%
8	31234	4.1%
b	30824	4.1%
t	29574	3.9%
o	29574	3.9%
Other values (15)	366333	48.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	754137	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	59148	7.8%
a	47233	6.3%
:	44361	5.9%
e	42479	5.6%
4	41899	5.6%
9	31478	4.2%
8	31234	4.1%
b	30824	4.1%
t	29574	3.9%
o	29574	3.9%
Other values (15)	366333	48.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	754137	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	59148	7.8%
a	47233	6.3%
:	44361	5.9%
e	42479	5.6%
4	41899	5.6%
9	31478	4.2%
8	31234	4.1%
b	30824	4.1%
t	29574	3.9%
o	29574	3.9%
Other values (15)	366333	48.6%

route_type
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Carting	8906
FTL	5881

Length

Max length	7
Median length	7
Mean length	5.4091432
Min length	3

Characters and Unicode

Total characters	79985
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FTL
2nd row	Carting
3rd row	FTL
4th row	Carting
5th row	FTL

Common Values

Value	Count	Frequency (%)
Carting	8906	60.2%
FTL	5881	39.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
carting	8906	60.2%
ftl	5881	39.8%

Most occurring characters

Value	Count	Frequency (%)
C	8906	11.1%
a	8906	11.1%
r	8906	11.1%
t	8906	11.1%
i	8906	11.1%
n	8906	11.1%
g	8906	11.1%
F	5881	7.4%
T	5881	7.4%
L	5881	7.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	79985	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	8906	11.1%
a	8906	11.1%
r	8906	11.1%
t	8906	11.1%
i	8906	11.1%
n	8906	11.1%
g	8906	11.1%
F	5881	7.4%
T	5881	7.4%
L	5881	7.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	79985	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	8906	11.1%
a	8906	11.1%
r	8906	11.1%
t	8906	11.1%
i	8906	11.1%
n	8906	11.1%
g	8906	11.1%
F	5881	7.4%
T	5881	7.4%
L	5881	7.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	79985	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	8906	11.1%
a	8906	11.1%
r	8906	11.1%
t	8906	11.1%
i	8906	11.1%
n	8906	11.1%
g	8906	11.1%
F	5881	7.4%
T	5881	7.4%
L	5881	7.4%

start_scan_to_end_scan
Real number (ℝ)

High correlation

Distinct	2203
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	529.42903

Minimum	23
Maximum	7898
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	23
5-th percentile	71
Q1	149
median	279
Q3	632
95-th percentile	1892.1
Maximum	7898
Range	7875
Interquartile range (IQR)	483

Descriptive statistics

Standard deviation	658.25494
Coefficient of variation (CV)	1.2433299
Kurtosis	11.100934
Mean	529.42903
Median Absolute Deviation (MAD)	164
Skewness	2.8953365
Sum	7828667
Variance	433299.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
115	51	0.3%
148	51	0.3%
87	50	0.3%
128	49	0.3%
113	49	0.3%
170	48	0.3%
105	48	0.3%
99	48	0.3%
150	47	0.3%
135	47	0.3%
Other values (2193)	14299	96.7%

Value	Count	Frequency (%)
23	1	< 0.1%
26	2	< 0.1%
27	3	< 0.1%
28	4	< 0.1%
29	2	< 0.1%
30	2	< 0.1%
31	8	0.1%
32	4	< 0.1%
33	8	0.1%
34	11	0.1%

Value	Count	Frequency (%)
7898	1	< 0.1%
7458	1	< 0.1%
6495	1	< 0.1%
5864	1	< 0.1%
5807	1	< 0.1%
5688	1	< 0.1%
5686	1	< 0.1%
4846	1	< 0.1%
4699	1	< 0.1%
4616	1	< 0.1%

actual_distance_to_destination
Real number (ℝ)

High correlation

Distinct	14771
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	164.0902

Minimum	9.0024614
Maximum	2186.5318
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	9.0024614
5-th percentile	11.097212
Q1	22.777099
median	48.287894
Q3	163.59126
95-th percentile	829.17455
Maximum	2186.5318
Range	2177.5293
Interquartile range (IQR)	140.81416

Descriptive statistics

Standard deviation	305.50298
Coefficient of variation (CV)	1.8617991
Kurtosis	13.699595
Mean	164.0902
Median Absolute Deviation (MAD)	33.249556
Skewness	3.5629313
Sum	2426401.7
Variance	93332.072
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.18625572	2	< 0.1%
32.17709214	2	< 0.1%
17.48464859	2	< 0.1%
26.58161002	2	< 0.1%
25.1427725	2	< 0.1%
195.5579057	2	< 0.1%
23.03404243	2	< 0.1%
27.95996726	2	< 0.1%
18.03636646	2	< 0.1%
25.24434706	2	< 0.1%
Other values (14761)	14767	99.9%

Value	Count	Frequency (%)
9.002461442	1	< 0.1%
9.003577518	1	< 0.1%
9.004037718	1	< 0.1%
9.006254595	1	< 0.1%
9.006827116	1	< 0.1%
9.007520875	1	< 0.1%
9.007658103	1	< 0.1%
9.01049775	1	< 0.1%
9.016697542	1	< 0.1%
9.018870024	1	< 0.1%

Value	Count	Frequency (%)
2186.531787	1	< 0.1%
2186.098218	1	< 0.1%
2185.663823	1	< 0.1%
2185.480257	1	< 0.1%
2185.379628	1	< 0.1%
2185.371321	1	< 0.1%
2184.055501	1	< 0.1%
2183.749474	1	< 0.1%
2183.481081	1	< 0.1%
2183.315555	1	< 0.1%

actual_time
Real number (ℝ)

High correlation

Distinct	1850
Distinct (%)	12.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	356.30601

Minimum	9
Maximum	6265
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	9
5-th percentile	32
Q1	67
median	148
Q3	367
95-th percentile	1472.4
Maximum	6265
Range	6256
Interquartile range (IQR)	300

Descriptive statistics

Standard deviation	561.51794
Coefficient of variation (CV)	1.5759429
Kurtosis	13.836985
Mean	356.30601
Median Absolute Deviation (MAD)	99
Skewness	3.3751783
Sum	5268697
Variance	315302.39
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	134	0.9%
50	130	0.9%
42	121	0.8%
48	115	0.8%
38	111	0.8%
54	107	0.7%
72	103	0.7%
58	101	0.7%
66	99	0.7%
36	94	0.6%
Other values (1840)	13672	92.5%

Value	Count	Frequency (%)
9	2	< 0.1%
10	4	< 0.1%
11	6	< 0.1%
12	8	0.1%
13	16	0.1%
14	28	0.2%
15	14	0.1%
16	19	0.1%
17	18	0.1%
18	31	0.2%

Value	Count	Frequency (%)
6265	1	< 0.1%
5804	1	< 0.1%
5465	1	< 0.1%
5067	1	< 0.1%
5064	1	< 0.1%
4687	1	< 0.1%
4532	1	< 0.1%
4267	1	< 0.1%
4263	1	< 0.1%
4154	1	< 0.1%

osrm_time
Real number (ℝ)

High correlation

Distinct	814
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	160.99094

Minimum	6
Maximum	2032
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	6
5-th percentile	14
Q1	29
median	60
Q3	168
95-th percentile	710
Maximum	2032
Range	2026
Interquartile range (IQR)	139

Descriptive statistics

Standard deviation	271.45949
Coefficient of variation (CV)	1.6861787
Kurtosis	13.248508
Mean	160.99094
Median Absolute Deviation (MAD)	40
Skewness	3.455256
Sum	2380573
Variance	73690.257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34	268	1.8%
20	262	1.8%
29	261	1.8%
23	240	1.6%
32	238	1.6%
22	233	1.6%
17	223	1.5%
33	215	1.5%
16	206	1.4%
21	203	1.4%
Other values (804)	12438	84.1%

Value	Count	Frequency (%)
6	1	< 0.1%
7	19	0.1%
8	35	0.2%
9	39	0.3%
10	88	0.6%
11	118	0.8%
12	167	1.1%
13	136	0.9%
14	147	1.0%
15	199	1.3%

Value	Count	Frequency (%)
2032	2	< 0.1%
2031	2	< 0.1%
2030	1	< 0.1%
1917	1	< 0.1%
1873	3	< 0.1%
1872	1	< 0.1%
1871	5	< 0.1%
1870	4	< 0.1%
1869	2	< 0.1%
1867	1	< 0.1%

osrm_distance
Real number (ℝ)

High correlation

Distinct	14702
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	203.88741

Minimum	9.0729
Maximum	2840.081
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	9.0729
5-th percentile	14.96663
Q1	30.7569
median	65.3028
Q3	206.6442
95-th percentile	969.58967
Maximum	2840.081
Range	2831.0081
Interquartile range (IQR)	175.8873

Descriptive statistics

Standard deviation	370.56556
Coefficient of variation (CV)	1.817501
Kurtosis	13.823126
Mean	203.88741
Median Absolute Deviation (MAD)	45.2799
Skewness	3.5536187
Sum	3014883.2
Variance	137318.84
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.7346	2	< 0.1%
13.4217	2	< 0.1%
17.8604	2	< 0.1%
34.7344	2	< 0.1%
20.0424	2	< 0.1%
16.346	2	< 0.1%
27.7116	2	< 0.1%
37.0811	2	< 0.1%
78.7434	2	< 0.1%
13.0535	2	< 0.1%
Other values (14692)	14767	99.9%

Value	Count	Frequency (%)
9.0729	1	< 0.1%
9.1364	1	< 0.1%
9.2903	1	< 0.1%
9.3227	1	< 0.1%
9.3301	1	< 0.1%
9.3353	1	< 0.1%
9.3908	1	< 0.1%
9.3999	1	< 0.1%
9.4185	1	< 0.1%
9.6473	1	< 0.1%

Value	Count	Frequency (%)
2840.081	1	< 0.1%
2839.6603	1	< 0.1%
2839.3582	1	< 0.1%
2838.8811	1	< 0.1%
2837.7608	1	< 0.1%
2670.2059	1	< 0.1%
2555.7542	1	< 0.1%
2555.6566	1	< 0.1%
2555.5269	1	< 0.1%
2555.4428	1	< 0.1%

segment_actual_time_sum
Real number (ℝ)

High correlation

Distinct	1885
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	353.05917

Minimum	9
Maximum	6230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	9
5-th percentile	32
Q1	66
median	147
Q3	364
95-th percentile	1458.2
Maximum	6230
Range	6221
Interquartile range (IQR)	298

Descriptive statistics

Standard deviation	556.36591
Coefficient of variation (CV)	1.5758432
Kurtosis	13.833819
Mean	353.05917
Median Absolute Deviation (MAD)	99
Skewness	3.3720425
Sum	5220686
Variance	309543.03
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47	121	0.8%
41	112	0.8%
60	107	0.7%
55	100	0.7%
35	100	0.7%
53	98	0.7%
49	98	0.7%
39	98	0.7%
45	95	0.6%
74	94	0.6%
Other values (1875)	13764	93.1%

Value	Count	Frequency (%)
9	2	< 0.1%
10	4	< 0.1%
11	6	< 0.1%
12	9	0.1%
13	20	0.1%
14	27	0.2%
15	14	0.1%
16	16	0.1%
17	27	0.2%
18	28	0.2%

Value	Count	Frequency (%)
6230	1	< 0.1%
5768	1	< 0.1%
5427	1	< 0.1%
5032	1	< 0.1%
5028	1	< 0.1%
4642	1	< 0.1%
4504	1	< 0.1%
4222	1	< 0.1%
4214	1	< 0.1%
4129	1	< 0.1%

segment_osrm_time_sum
Real number (ℝ)

High correlation

Distinct	1240
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180.5116

Minimum	6
Maximum	2564
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	6
5-th percentile	15
Q1	30
median	65
Q3	184
95-th percentile	833.7
Maximum	2564
Range	2558
Interquartile range (IQR)	154

Descriptive statistics

Standard deviation	314.67928
Coefficient of variation (CV)	1.7432635
Kurtosis	14.570176
Mean	180.5116
Median Absolute Deviation (MAD)	45
Skewness	3.6029152
Sum	2669225
Variance	99023.049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	221	1.5%
20	213	1.4%
19	210	1.4%
18	209	1.4%
22	208	1.4%
23	204	1.4%
21	188	1.3%
28	184	1.2%
35	180	1.2%
30	180	1.2%
Other values (1230)	12790	86.5%

Value	Count	Frequency (%)
6	1	< 0.1%
7	22	0.1%
8	25	0.2%
9	61	0.4%
10	79	0.5%
11	115	0.8%
12	151	1.0%
13	131	0.9%
14	125	0.8%
15	175	1.2%

Value	Count	Frequency (%)
2564	1	< 0.1%
2530	1	< 0.1%
2510	1	< 0.1%
2494	1	< 0.1%
2422	1	< 0.1%
2350	1	< 0.1%
2346	1	< 0.1%
2326	1	< 0.1%
2320	1	< 0.1%
2313	1	< 0.1%

segment_osrm_distance_sum
Real number (ℝ)

High correlation

Distinct	14718
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	222.70547

Minimum	9.0729
Maximum	3523.6324
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	9.0729
5-th percentile	15.36056
Q1	32.57885
median	69.7842
Q3	216.5606
95-th percentile	1106.2946
Maximum	3523.6324
Range	3514.5595
Interquartile range (IQR)	183.98175

Descriptive statistics

Standard deviation	416.84628
Coefficient of variation (CV)	1.871738
Kurtosis	15.372075
Mean	222.70547
Median Absolute Deviation (MAD)	49.1334
Skewness	3.7140165
Sum	3293145.7
Variance	173760.82
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.1177	2	< 0.1%
51.5355	2	< 0.1%
45.6356	2	< 0.1%
32.9795	2	< 0.1%
27.5998	2	< 0.1%
14.95	2	< 0.1%
16.1861	2	< 0.1%
38.1914	2	< 0.1%
50.6246	2	< 0.1%
19.5174	2	< 0.1%
Other values (14708)	14767	99.9%

Value	Count	Frequency (%)
9.0729	1	< 0.1%
9.1364	1	< 0.1%
9.2903	1	< 0.1%
9.3227	1	< 0.1%
9.3301	1	< 0.1%
9.3353	1	< 0.1%
9.3908	1	< 0.1%
9.3999	1	< 0.1%
9.4185	1	< 0.1%
9.6473	1	< 0.1%

Value	Count	Frequency (%)
3523.6324	1	< 0.1%
3489.9866	1	< 0.1%
3456.0357	1	< 0.1%
3418.1829	1	< 0.1%
3367.3834	1	< 0.1%
3251.1052	1	< 0.1%
3250.869	1	< 0.1%
3238.744	1	< 0.1%
3213.4054	1	< 0.1%
3204.0404	1	< 0.1%

od_time_diff_hour
Real number (ℝ)

High correlation Unique

Distinct	14787
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	546.12445

Minimum	23.461468
Maximum	7898.552
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	23.461468
5-th percentile	71.203377
Q1	150.93155
median	287.42123
Q3	670.64299
95-th percentile	1939.7819
Maximum	7898.552
Range	7875.0905
Interquartile range (IQR)	519.71144

Descriptive statistics

Standard deviation	668.16505
Coefficient of variation (CV)	1.2234666
Kurtosis	10.25297
Mean	546.12445
Median Absolute Deviation (MAD)	172.71894
Skewness	2.7775483
Sum	8075542.2
Variance	446444.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
354.4075714	1	< 0.1%
2260.1098	1	< 0.1%
181.6118738	1	< 0.1%
148.7947178	1	< 0.1%
158.3375369	1	< 0.1%
254.721952	1	< 0.1%
257.7081947	1	< 0.1%
113.8599436	1	< 0.1%
2182.120429	1	< 0.1%
1019.486964	1	< 0.1%
Other values (14777)	14777	99.9%

Value	Count	Frequency (%)
23.46146848	1	< 0.1%
26.49916442	1	< 0.1%
26.5808515	1	< 0.1%
27.63686067	1	< 0.1%
27.73261922	1	< 0.1%
27.79866977	1	< 0.1%
28.17911532	1	< 0.1%
28.42774028	1	< 0.1%
28.92702358	1	< 0.1%
28.98354038	1	< 0.1%

Value	Count	Frequency (%)
7898.551955	1	< 0.1%
7458.939519	1	< 0.1%
6496.022231	1	< 0.1%
5864.79313	1	< 0.1%
5807.995124	1	< 0.1%
5689.14172	1	< 0.1%
5686.743719	1	< 0.1%
4847.14009	1	< 0.1%
4699.692937	1	< 0.1%
4616.736291	1	< 0.1%

dest_state
Categorical

High correlation

Distinct	32
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

maharashtra	2549
karnataka	2303
haryana	1567
tamil nadu	1043
uttar pradesh	866
Other values (27)	6459

Length

Max length	22
Median length	16
Mean length	9.273754
Min length	3

Characters and Unicode

Total characters	137131
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	uttar pradesh
2nd row	karnataka
3rd row	haryana
4th row	maharashtra
5th row	karnataka

Common Values

Value	Count	Frequency (%)
maharashtra	2549	17.2%
karnataka	2303	15.6%
haryana	1567	10.6%
tamil nadu	1043	7.1%
uttar pradesh	866	5.9%
gujarat	739	5.0%
telangana	730	4.9%
west bengal	665	4.5%
delhi	627	4.2%
rajasthan	556	3.8%
Other values (22)	3142	21.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
maharashtra	2549	13.8%
karnataka	2303	12.5%
pradesh	1826	9.9%
haryana	1567	8.5%
tamil	1043	5.7%
nadu	1043	5.7%
uttar	866	4.7%
gujarat	739	4.0%
telangana	730	4.0%
west	665	3.6%
Other values (31)	5093	27.6%

Most occurring characters

Value	Count	Frequency (%)
a	40243	29.3%
r	14837	10.8%
h	12011	8.8%
t	10670	7.8%
n	9084	6.6%
s	6474	4.7%
k	5242	3.8%
e	4834	3.5%
d	4826	3.5%
m	4388	3.2%
Other values (15)	24522	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	137131	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	40243	29.3%
r	14837	10.8%
h	12011	8.8%
t	10670	7.8%
n	9084	6.6%
s	6474	4.7%
k	5242	3.8%
e	4834	3.5%
d	4826	3.5%
m	4388	3.2%
Other values (15)	24522	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	137131	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	40243	29.3%
r	14837	10.8%
h	12011	8.8%
t	10670	7.8%
n	9084	6.6%
s	6474	4.7%
k	5242	3.8%
e	4834	3.5%
d	4826	3.5%
m	4388	3.2%
Other values (15)	24522	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	137131	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	40243	29.3%
r	14837	10.8%
h	12011	8.8%
t	10670	7.8%
n	9084	6.6%
s	6474	4.7%
k	5242	3.8%
e	4834	3.5%
d	4826	3.5%
m	4388	3.2%
Other values (15)	24522	17.9%

dest_city
Text

Distinct	919
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	22
Median length	17
Mean length	7.4887401
Min length	2

Characters and Unicode

Total characters	110736
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	207 ?
Unique (%)	1.4%

Sample

1st row	kanpur
2nd row	doddablpur
3rd row	gurgaon
4th row	mumbai
5th row	hospet

Value	Count	Frequency (%)
mumbai	1159	7.4%
bengaluru	1122	7.2%
gurgaon	842	5.4%
delhi	510	3.3%
bangalore	503	3.2%
hyderabad	426	2.7%
chennai	413	2.7%
bhiwandi	396	2.5%
pune	296	1.9%
sonipat	278	1.8%
Other values (906)	9631	61.8%

Most occurring characters

Value	Count	Frequency (%)
a	20018	18.1%
r	8966	8.1%
n	8464	7.6%
u	8283	7.5%
i	6929	6.3%
h	6093	5.5%
b	5940	5.4%
g	5547	5.0%
d	5345	4.8%
l	4981	4.5%
Other values (17)	30170	27.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110736	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	20018	18.1%
r	8966	8.1%
n	8464	7.6%
u	8283	7.5%
i	6929	6.3%
h	6093	5.5%
b	5940	5.4%
g	5547	5.0%
d	5345	4.8%
l	4981	4.5%
Other values (17)	30170	27.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110736	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	20018	18.1%
r	8966	8.1%
n	8464	7.6%
u	8283	7.5%
i	6929	6.3%
h	6093	5.5%
b	5940	5.4%
g	5547	5.0%
d	5345	4.8%
l	4981	4.5%
Other values (17)	30170	27.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110736	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	20018	18.1%
r	8966	8.1%
n	8464	7.6%
u	8283	7.5%
i	6929	6.3%
h	6093	5.5%
b	5940	5.4%
g	5547	5.0%
d	5345	4.8%
l	4981	4.5%
Other values (17)	30170	27.2%

dest_place
Text

Distinct	914
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	16
Median length	8
Mean length	7.4470143
Min length	1

Characters and Unicode

Total characters	110119
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	191 ?
Unique (%)	1.3%

Sample

1st row	central
2nd row	chikadpp
3rd row	bilaspur
4th row	mirard
5th row	hospet

Value	Count	Frequency (%)
bilaspur	829	5.6%
central	767	5.1%
nelmngla	503	3.4%
mankoli	396	2.7%
bomsndra	358	2.4%
shamshbd	283	1.9%
kundli	276	1.9%
kgairprt	272	1.8%
mumbai	237	1.6%
tathawde	231	1.5%
Other values (907)	10754	72.1%

Most occurring characters

Value	Count	Frequency (%)
a	15478	14.1%
r	10739	9.8%
n	8757	8.0%
l	6465	5.9%
d	5956	5.4%
i	5955	5.4%
p	5703	5.2%
h	5497	5.0%
m	5123	4.7%
t	4755	4.3%
Other values (28)	35691	32.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110119	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	15478	14.1%
r	10739	9.8%
n	8757	8.0%
l	6465	5.9%
d	5956	5.4%
i	5955	5.4%
p	5703	5.2%
h	5497	5.0%
m	5123	4.7%
t	4755	4.3%
Other values (28)	35691	32.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110119	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	15478	14.1%
r	10739	9.8%
n	8757	8.0%
l	6465	5.9%
d	5956	5.4%
i	5955	5.4%
p	5703	5.2%
h	5497	5.0%
m	5123	4.7%
t	4755	4.3%
Other values (28)	35691	32.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110119	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	15478	14.1%
r	10739	9.8%
n	8757	8.0%
l	6465	5.9%
d	5956	5.4%
i	5955	5.4%
p	5703	5.2%
h	5497	5.0%
m	5123	4.7%
t	4755	4.3%
Other values (28)	35691	32.4%

dest_code
Text

Distinct	57
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	15
Median length	2
Mean length	2.6654494
Min length	2

Characters and Unicode

Total characters	39414
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	6
2nd row	d
3rd row	hb
4th row	ip
5th row	none

Value	Count	Frequency (%)
d	3709	25.1%
hb	2087	14.1%
h	1651	11.2%
dc	1246	8.4%
i	976	6.6%
dpc	877	5.9%
none	801	5.4%
l	615	4.2%
ip	565	3.8%
hub	361	2.4%
Other values (49)	1915	12.9%

Most occurring characters

Value	Count	Frequency (%)
	14002	35.5%
d	5856	14.9%
h	4144	10.5%
c	2550	6.5%
b	2461	6.2%
p	2075	5.3%
n	1691	4.3%
i	1646	4.2%
e	979	2.5%
o	853	2.2%
Other values (23)	3157	8.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	39414	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	14002	35.5%
d	5856	14.9%
h	4144	10.5%
c	2550	6.5%
b	2461	6.2%
p	2075	5.3%
n	1691	4.3%
i	1646	4.2%
e	979	2.5%
o	853	2.2%
Other values (23)	3157	8.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	39414	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	14002	35.5%
d	5856	14.9%
h	4144	10.5%
c	2550	6.5%
b	2461	6.2%
p	2075	5.3%
n	1691	4.3%
i	1646	4.2%
e	979	2.5%
o	853	2.2%
Other values (23)	3157	8.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	39414	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	14002	35.5%
d	5856	14.9%
h	4144	10.5%
c	2550	6.5%
b	2461	6.2%
p	2075	5.3%
n	1691	4.3%
i	1646	4.2%
e	979	2.5%
o	853	2.2%
Other values (23)	3157	8.0%

source_state
Categorical

High correlation

Distinct	29
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

maharashtra	2682
karnataka	2229
haryana	1669
tamil nadu	1085
delhi	790
Other values (24)	6332

Length

Max length	22
Median length	16
Mean length	9.0933252
Min length	3

Characters and Unicode

Total characters	134463
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	madhya pradesh
2nd row	karnataka
3rd row	karnataka
4th row	maharashtra
5th row	karnataka

Common Values

Value	Count	Frequency (%)
maharashtra	2682	18.1%
karnataka	2229	15.1%
haryana	1669	11.3%
tamil nadu	1085	7.3%
delhi	790	5.3%
telangana	779	5.3%
gujarat	746	5.0%
uttar pradesh	719	4.9%
west bengal	677	4.6%
punjab	630	4.3%
Other values (19)	2781	18.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
maharashtra	2682	14.8%
karnataka	2229	12.3%
haryana	1669	9.2%
pradesh	1497	8.3%
tamil	1085	6.0%
nadu	1085	6.0%
delhi	790	4.4%
telangana	779	4.3%
gujarat	746	4.1%
uttar	719	4.0%
Other values (27)	4844	26.7%

Most occurring characters

Value	Count	Frequency (%)
a	39853	29.6%
r	14322	10.7%
h	11686	8.7%
t	10443	7.8%
n	9126	6.8%
s	6169	4.6%
k	5038	3.7%
e	4736	3.5%
d	4496	3.3%
m	4466	3.3%
Other values (15)	24128	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	134463	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	39853	29.6%
r	14322	10.7%
h	11686	8.7%
t	10443	7.8%
n	9126	6.8%
s	6169	4.6%
k	5038	3.7%
e	4736	3.5%
d	4496	3.3%
m	4466	3.3%
Other values (15)	24128	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	134463	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	39853	29.6%
r	14322	10.7%
h	11686	8.7%
t	10443	7.8%
n	9126	6.8%
s	6169	4.6%
k	5038	3.7%
e	4736	3.5%
d	4496	3.3%
m	4466	3.3%
Other values (15)	24128	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	134463	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	39853	29.6%
r	14322	10.7%
h	11686	8.7%
t	10443	7.8%
n	9126	6.8%
s	6169	4.6%
k	5038	3.7%
e	4736	3.5%
d	4496	3.3%
m	4466	3.3%
Other values (15)	24128	17.9%

source_city
Text

Distinct	679
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	22
Median length	17
Mean length	7.4769054
Min length	3

Characters and Unicode

Total characters	110561
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	235 ?
Unique (%)	1.6%

Sample

1st row	bhopal
2nd row	tumkur
3rd row	bangalore
4th row	mumbai hub
5th row	bellary

Value	Count	Frequency (%)
bengaluru	1015	6.6%
gurgaon	1013	6.6%
mumbai	893	5.8%
bhiwandi	811	5.3%
bangalore	755	4.9%
delhi	617	4.0%
hyderabad	562	3.6%
pune	445	2.9%
chandigarh	418	2.7%
kolkata	339	2.2%
Other values (668)	8576	55.5%

Most occurring characters

Value	Count	Frequency (%)
a	19689	17.8%
r	8818	8.0%
u	8127	7.4%
n	8096	7.3%
i	7138	6.5%
h	6379	5.8%
b	6317	5.7%
d	5923	5.4%
g	5685	5.1%
e	5447	4.9%
Other values (17)	28942	26.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110561	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	19689	17.8%
r	8818	8.0%
u	8127	7.4%
n	8096	7.3%
i	7138	6.5%
h	6379	5.8%
b	6317	5.7%
d	5923	5.4%
g	5685	5.1%
e	5447	4.9%
Other values (17)	28942	26.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110561	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	19689	17.8%
r	8818	8.0%
u	8127	7.4%
n	8096	7.3%
i	7138	6.5%
h	6379	5.8%
b	6317	5.7%
d	5923	5.4%
g	5685	5.1%
e	5447	4.9%
Other values (17)	28942	26.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110561	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	19689	17.8%
r	8818	8.0%
u	8127	7.4%
n	8096	7.3%
i	7138	6.5%
h	6379	5.8%
b	6317	5.7%
d	5923	5.4%
g	5685	5.1%
e	5447	4.9%
Other values (17)	28942	26.2%

source_place
Text

Distinct	713
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	16
Median length	14
Mean length	7.397579
Min length	3

Characters and Unicode

Total characters	109388
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	227 ?
Unique (%)	1.5%

Sample

1st row	trnsport
2nd row	veersagr
3rd row	nelmngla
4th row	mumbai
5th row	bellary

Value	Count	Frequency (%)
central	1039	7.0%
bilaspur	959	6.5%
mankoli	811	5.5%
nelmngla	732	4.9%
bomsndra	428	2.9%
mehmdpur	370	2.5%
east	363	2.4%
tathawde	361	2.4%
kgairprt	331	2.2%
mumbai	325	2.2%
Other values (707)	9141	61.5%

Most occurring characters

Value	Count	Frequency (%)
a	15560	14.2%
r	9555	8.7%
n	9070	8.3%
l	7525	6.9%
i	6422	5.9%
m	5797	5.3%
e	5756	5.3%
t	5269	4.8%
h	4979	4.6%
p	4769	4.4%
Other values (28)	34686	31.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	109388	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	15560	14.2%
r	9555	8.7%
n	9070	8.3%
l	7525	6.9%
i	6422	5.9%
m	5797	5.3%
e	5756	5.3%
t	5269	4.8%
h	4979	4.6%
p	4769	4.4%
Other values (28)	34686	31.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	109388	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	15560	14.2%
r	9555	8.7%
n	9070	8.3%
l	7525	6.9%
i	6422	5.9%
m	5797	5.3%
e	5756	5.3%
t	5269	4.8%
h	4979	4.6%
p	4769	4.4%
Other values (28)	34686	31.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	109388	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	15560	14.2%
r	9555	8.7%
n	9070	8.3%
l	7525	6.9%
i	6422	5.9%
m	5797	5.3%
e	5756	5.3%
t	5269	4.8%
h	4979	4.6%
p	4769	4.4%
Other values (28)	34686	31.7%

source_code
Text

Distinct	57
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

Length

Max length	15
Median length	2
Mean length	2.6577399
Min length	2

Characters and Unicode

Total characters	39300
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	h
2nd row	i
3rd row	h
4th row	none
5th row	dc

Value	Count	Frequency (%)
hb	3305	22.3%
h	2739	18.5%
d	1519	10.2%
i	1329	9.0%
none	640	4.3%
ip	622	4.2%
1	597	4.0%
dpc	593	4.0%
dc	501	3.4%
hub	495	3.3%
Other values (51)	2498	16.8%

Most occurring characters

Value	Count	Frequency (%)
	14198	36.1%
h	6584	16.8%
b	3821	9.7%
d	2693	6.9%
i	2043	5.2%
c	1916	4.9%
p	1897	4.8%
n	1336	3.4%
o	751	1.9%
1	694	1.8%
Other values (24)	3367	8.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	39300	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	14198	36.1%
h	6584	16.8%
b	3821	9.7%
d	2693	6.9%
i	2043	5.2%
c	1916	4.9%
p	1897	4.8%
n	1336	3.4%
o	751	1.9%
1	694	1.8%
Other values (24)	3367	8.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	39300	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	14198	36.1%
h	6584	16.8%
b	3821	9.7%
d	2693	6.9%
i	2043	5.2%
c	1916	4.9%
p	1897	4.8%
n	1336	3.4%
o	751	1.9%
1	694	1.8%
Other values (24)	3367	8.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	39300	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	14198	36.1%
h	6584	16.8%
b	3821	9.7%
d	2693	6.9%
i	2043	5.2%
c	1916	4.9%
p	1897	4.8%
n	1336	3.4%
o	751	1.9%
1	694	1.8%
Other values (24)	3367	8.6%

trip_month
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	115.7 KiB

9	13011
10	1776

Length

Max length	2
Median length	1
Mean length	1.1201055
Min length	1

Characters and Unicode

Total characters	16563
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	9
3rd row	9
4th row	9
5th row	9

Common Values

Value	Count	Frequency (%)
9	13011	88.0%
10	1776	12.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	13011	88.0%
10	1776	12.0%

Most occurring characters

Value	Count	Frequency (%)
9	13011	78.6%
1	1776	10.7%
0	1776	10.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	16563	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	13011	78.6%
1	1776	10.7%
0	1776	10.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	16563	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	13011	78.6%
1	1776	10.7%
0	1776	10.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	16563	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	13011	78.6%
1	1776	10.7%
0	1776	10.7%

trip_hour
Real number (ℝ)

Zeros

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.456212

Minimum	0
Maximum	23
Zeros	991
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	14
Q3	20
95-th percentile	23
Maximum	23
Range	23
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	7.9873869
Coefficient of variation (CV)	0.64123726
Kurtosis	-1.4960835
Mean	12.456212
Median Absolute Deviation (MAD)	7
Skewness	-0.20609177
Sum	184190
Variance	63.79835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
22	1123	7.6%
23	1107	7.5%
20	1080	7.3%
0	991	6.7%
21	872	5.9%
19	837	5.7%
1	748	5.1%
2	702	4.7%
18	696	4.7%
3	651	4.4%
Other values (14)	5980	40.4%

Value	Count	Frequency (%)
0	991	6.7%
1	748	5.1%
2	702	4.7%
3	651	4.4%
4	635	4.3%
5	505	3.4%
6	610	4.1%
7	472	3.2%
8	345	2.3%
9	317	2.1%

Value	Count	Frequency (%)
23	1107	7.5%
22	1123	7.6%
21	872	5.9%
20	1080	7.3%
19	837	5.7%
18	696	4.7%
17	595	4.0%
16	526	3.6%
15	469	3.2%
14	379	2.6%

trip_day
Real number (ℝ)

High correlation

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.375127

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	14
median	19
Q3	25
95-th percentile	29
Maximum	30
Range	29
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.8821985
Coefficient of variation (CV)	0.42896022
Kurtosis	-0.1620419
Mean	18.375127
Median Absolute Deviation (MAD)	5
Skewness	-0.69524137
Sum	271713
Variance	62.129053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
18	791	5.3%
15	783	5.3%
13	750	5.1%
12	747	5.1%
21	740	5.0%
22	740	5.0%
17	722	4.9%
14	712	4.8%
20	703	4.8%
25	695	4.7%
Other values (12)	7404	50.1%

Value	Count	Frequency (%)
1	600	4.1%
2	549	3.7%
3	627	4.2%
12	747	5.1%
13	750	5.1%
14	712	4.8%
15	783	5.3%
16	616	4.2%
17	722	4.9%
18	791	5.3%

Value	Count	Frequency (%)
30	506	3.4%
29	605	4.1%
28	605	4.1%
27	650	4.4%
26	683	4.6%
25	695	4.7%
24	658	4.4%
23	631	4.3%
22	740	5.0%
21	740	5.0%

trip_dayofweek
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.9209441

Minimum	0
Maximum	6
Zeros	1980
Zeros (%)	13.4%
Negative	0
Negative (%)	0.0%
Memory size	115.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9276895
Coefficient of variation (CV)	0.65995428
Kurtosis	-1.1685046
Mean	2.9209441
Median Absolute Deviation (MAD)	2
Skewness	0.065904383
Sum	43192
Variance	3.715987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	2731	18.5%
5	2128	14.4%
3	2103	14.2%
4	2057	13.9%
1	2035	13.8%
0	1980	13.4%
6	1753	11.9%

Value	Count	Frequency (%)
0	1980	13.4%
1	2035	13.8%
2	2731	18.5%
3	2103	14.2%
4	2057	13.9%
5	2128	14.4%
6	1753	11.9%

Value	Count	Frequency (%)
6	1753	11.9%
5	2128	14.4%
4	2057	13.9%
3	2103	14.2%
2	2731	18.5%
1	2035	13.8%
0	1980	13.4%

Interactions

Correlations

	actual_distance_to_destination	actual_time	dest_state	od_time_diff_hour	osrm_distance	osrm_time	route_type	segment_actual_time_sum	segment_osrm_distance_sum	segment_osrm_time_sum	source_state	start_scan_to_end_scan	trip_day	trip_dayofweek	trip_hour	trip_month
actual_distance_to_destination	1.000	0.903	0.169	0.840	0.991	0.979	0.528	0.902	0.984	0.968	0.138	0.841	-0.004	0.002	0.085	0.033
actual_time	0.903	1.000	0.145	0.897	0.911	0.906	0.474	1.000	0.910	0.902	0.121	0.898	0.001	-0.006	0.024	0.020
dest_state	0.169	0.145	1.000	0.157	0.178	0.191	0.454	0.142	0.158	0.162	0.750	0.152	0.022	0.000	0.153	0.035
od_time_diff_hour	0.840	0.897	0.157	1.000	0.848	0.843	0.527	0.897	0.845	0.837	0.129	0.995	0.013	0.005	0.063	0.032
osrm_distance	0.991	0.911	0.178	0.848	1.000	0.990	0.518	0.910	0.991	0.979	0.141	0.849	-0.003	0.002	0.083	0.031
osrm_time	0.979	0.906	0.191	0.843	0.990	1.000	0.561	0.904	0.984	0.990	0.143	0.845	-0.004	0.003	0.086	0.029
route_type	0.528	0.474	0.454	0.527	0.518	0.561	1.000	0.472	0.476	0.508	0.404	0.507	0.043	0.030	0.152	0.027
segment_actual_time_sum	0.902	1.000	0.142	0.897	0.910	0.904	0.472	1.000	0.909	0.901	0.120	0.898	0.001	-0.006	0.024	0.020
segment_osrm_distance_sum	0.984	0.910	0.158	0.845	0.991	0.984	0.476	0.909	1.000	0.989	0.122	0.846	-0.003	0.002	0.081	0.032
segment_osrm_time_sum	0.968	0.902	0.162	0.837	0.979	0.990	0.508	0.901	0.989	1.000	0.127	0.839	-0.004	0.003	0.081	0.033
source_state	0.138	0.121	0.750	0.129	0.141	0.143	0.404	0.120	0.122	0.127	1.000	0.127	0.027	0.000	0.144	0.036
start_scan_to_end_scan	0.841	0.898	0.152	0.995	0.849	0.845	0.507	0.898	0.846	0.839	0.127	1.000	0.012	0.005	0.064	0.033
trip_day	-0.004	0.001	0.022	0.013	-0.003	-0.004	0.043	0.001	-0.003	-0.004	0.027	0.012	1.000	0.304	-0.009	1.000
trip_dayofweek	0.002	-0.006	0.000	0.005	0.002	0.003	0.030	-0.006	0.002	0.003	0.000	0.005	0.304	1.000	-0.028	0.408
trip_hour	0.085	0.024	0.153	0.063	0.083	0.086	0.152	0.024	0.081	0.081	0.144	0.064	-0.009	-0.028	1.000	0.021
trip_month	0.033	0.020	0.035	0.032	0.031	0.029	0.027	0.020	0.032	0.033	0.036	0.033	1.000	0.408	0.021	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	trip_uuid	trip_creation_time	route_schedule_uuid	route_type	start_scan_to_end_scan	actual_distance_to_destination	actual_time	osrm_time	osrm_distance	segment_actual_time_sum	segment_osrm_time_sum	segment_osrm_distance_sum	od_time_diff_hour	dest_state	dest_city	dest_place	dest_code	source_state	source_city	source_place	source_code	trip_month	trip_day	trip_dayofweek
0	trip-153671041653548748	2018-09-12 00:00:16.535741	thanos::sroute:d7c989ba-a29b-4a0b-b2f4-288cdc60074b	FTL	2259.0	824.732854	1562.0	717.0	991.3523	1548.0	1008.0	1320.4733	2260.109800	uttar pradesh	kanpur	central	6	madhya pradesh	bhopal	trnsport	h	9	12	2
1	trip-153671042288605164	2018-09-12 00:00:22.886430	thanos::sroute:3a1b0ab2-bb0b-4c53-8c59-eb2a2c0d68b9	Carting	180.0	73.186911	143.0	68.0	85.1110	141.0	65.0	84.1894	181.611874	karnataka	doddablpur	chikadpp	d	karnataka	tumkur	veersagr	i	9	12	2
2	trip-153671043369099517	2018-09-12 00:00:33.691250	thanos::sroute:de5e208e-7641-45e6-8100-4d9fb1e5720d	FTL	3933.0	1927.404273	3347.0	1740.0	2354.0665	3308.0	1941.0	2545.2678	3934.362520	haryana	gurgaon	bilaspur	hb	karnataka	bangalore	nelmngla	h	9	12	2
3	trip-153671046011330457	2018-09-12 00:01:00.113710	thanos::sroute:f0176492-a679-4597-8332-bbd1c7f9f442	Carting	100.0	17.175274	59.0	15.0	19.6800	59.0	16.0	19.8766	100.494935	maharashtra	mumbai	mirard	ip	maharashtra	mumbai hub	mumbai	none	9	12	2
4	trip-153671052974046625	2018-09-12 00:02:09.740725	thanos::sroute:d9f07b12-65e0-4f3b-bec8-df0613461b0f	FTL	717.0	127.448500	341.0	117.0	146.7918	340.0	115.0	146.7919	718.349042	karnataka	hospet	hospet	none	karnataka	bellary	bellary	dc	9	12	2
5	trip-153671055416136166	2018-09-12 00:02:34.161600	thanos::sroute:9bf03170-d0a2-4a3f-aa4d-9aaab3d98af4	Carting	189.0	24.597048	61.0	23.0	28.0647	60.0	23.0	28.0647	190.487849	tamil nadu	chennai	chennai	poonamallee	tamil nadu	chennai	porur	dpc	9	12	2
6	trip-153671066201138152	2018-09-12 00:04:22.011653	thanos::sroute:a97698cc-846e-41a7-916b-88b17412610c	Carting	98.0	9.100510	24.0	13.0	12.0184	24.0	13.0	12.0184	98.005634	tamil nadu	chennai	vandalur	dc	tamil nadu	chennai	chrompet	dpc	9	12	2
7	trip-153671066826362165	2018-09-12 00:04:28.263977	thanos::sroute:d5b71ae9-a11a-4f52-bcb7-274b65e2c513	Carting	146.0	22.424210	64.0	34.0	28.9203	64.0	34.0	28.9203	176.448324	karnataka	bengaluru	nwylhnka	dc	karnataka	hbr layout pc	hbr	none	9	12	2
8	trip-153671074033284934	2018-09-12 00:05:40.333071	thanos::sroute:a0e60427-16ad-4b17-b3b0-6a0664355ae1	Carting	280.0	25.454848	161.0	29.0	30.9359	161.0	29.0	30.9358	310.804135	gujarat	surat	central	3	gujarat	surat	central	4	9	12	2
9	trip-153671079956500691	2018-09-12 00:06:39.565253	thanos::sroute:a10888ff-f794-41e1-9b7a-7f62ef663dda	Carting	49.0	9.872146	23.0	8.0	9.9566	23.0	14.0	16.0860	49.333390	delhi	delhi	delhi	bhogal	delhi	delhi	lajpat	ip	9	12	2

	trip_uuid	trip_creation_time	route_schedule_uuid	route_type	start_scan_to_end_scan	actual_distance_to_destination	actual_time	osrm_time	osrm_distance	segment_actual_time_sum	segment_osrm_time_sum	segment_osrm_distance_sum	od_time_diff_hour	dest_state	dest_city	dest_place	dest_code	source_state	source_city	source_place	source_code	trip_month	trip_hour	trip_day	trip_dayofweek
14777	trip-153861089403973335	2018-10-03 23:54:54.039992	thanos::sroute:233c5ce2-a1e2-4550-945c-28c357cafe57	Carting	98.0	33.898361	49.0	27.0	36.4426	48.0	40.0	50.0725	98.726590	gujarat	anand	vaghasi	ip	gujarat	vadodara	karelibaug	dpc	10	23	3	2
14778	trip-153861089559302126	2018-10-03 23:54:55.593290	thanos::sroute:9c1c7ad6-d0e4-4077-b574-4ab11de60bc1	Carting	186.0	28.114091	86.0	30.0	34.9224	86.0	30.0	34.9223	231.326709	maharashtra	mumbai	ulhasngr	dc	maharashtra	mumbai	east	21	10	23	3	2
14779	trip-153861089872028474	2018-10-03 23:54:58.720536	thanos::sroute:27463ea7-5903-4530-92e7-6a4feca7b07c	Carting	181.0	27.010926	62.0	28.0	38.2867	61.0	33.0	33.6400	182.416663	tamil nadu	chennai	vepmpttu	dc	tamil nadu	chennai	porur	dpc	10	23	3	2
14780	trip-153861090163768194	2018-10-03 23:55:01.637939	thanos::sroute:9bf03170-d0a2-4a3f-aa4d-9aaab3d98af4	Carting	58.0	15.135009	42.0	12.0	15.8436	41.0	11.0	15.8436	58.171907	tamil nadu	chennai	sriperumbudur	dc	tamil nadu	chennai	chennai	poonamallee	10	23	3	2
14781	trip-153861091843037040	2018-10-03 23:55:18.430664	thanos::sroute:f0176492-a679-4597-8332-bbd1c7f9f442	Carting	88.0	17.760248	38.0	16.0	20.5065	37.0	16.0	20.5065	88.215987	maharashtra	mumbai	mirard	ip	maharashtra	mumbai hub	mumbai	none	10	23	3	2
14782	trip-153861095625827784	2018-10-03 23:55:56.258533	thanos::sroute:8a120994-f577-4491-9e4b-b7e4a1479d2f	Carting	257.0	57.762332	83.0	62.0	73.4630	82.0	62.0	64.8551	405.485842	punjab	zirakpur	zirakpur	dc	punjab	chandigarh	mehmdpur	h	10	23	3	2
14783	trip-153861104386292051	2018-10-03 23:57:23.863155	thanos::sroute:b30e1ec3-3bfa-4bd2-a7fb-3b757695fc1a	Carting	60.0	15.513784	21.0	12.0	16.0882	21.0	11.0	16.0883	60.590521	haryana	faridabad	blbgarh	dc	haryana	fbd	balabhgarh	dpc	10	23	3	2
14784	trip-153861106442901555	2018-10-03 23:57:44.429324	thanos::sroute:5609c268-e436-4e0a-8180-3db4a743161e	Carting	421.0	38.684839	282.0	48.0	58.9037	281.0	88.0	104.8866	422.119867	uttar pradesh	kanpur	govndngr	dc	uttar pradesh	kanpur	central	6	10	23	3	2
14785	trip-153861115439069069	2018-10-03 23:59:14.390954	thanos::sroute:c5f2ba2c-8486-4940-8af6-d1d2a6a37a00	Carting	347.0	134.723836	264.0	179.0	171.1103	258.0	221.0	223.5324	348.512862	tamil nadu	eral	busstand	d	tamil nadu	tirunelveli	vdkkusrt	i	10	23	3	2
14786	trip-153861118270144424	2018-10-03 23:59:42.701692	thanos::sroute:412fea14-6d1f-4222-8a5f-a5170425649b	FTL	353.0	66.081533	275.0	68.0	80.5787	274.0	67.0	80.5787	354.407571	karnataka	sandur	wrdn1dpp	d	karnataka	hospet	hospet	none	10	23	3	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters